/**
 * BladeX Commercial License Agreement
 * Copyright (c) 2018-2099, https://bladex.cn. All rights reserved.
 * <p>
 * Use of this software is governed by the Commercial License Agreement
 * obtained after purchasing a license from BladeX.
 * <p>
 * 1. This software is for development use only under a valid license
 * from BladeX.
 * <p>
 * 2. Redistribution of this software's source code to any third party
 * without a commercial license is strictly prohibited.
 * <p>
 * 3. Licensees may copyright their own code but cannot use segments
 * from this software for such purposes. Copyright of this software
 * remains with BladeX.
 * <p>
 * Using this software signifies agreement to this License, and the software
 * must not be used for illegal purposes.
 * <p>
 * THIS SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY. The author is
 * not liable for any claims arising from secondary or illegal development.
 * <p>
 * Author: Chill Zhuang (bladejava@qq.com)
 */
package org.springblade.modules.signup.controller;

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import io.swagger.v3.oas.annotations.tags.Tag;
import io.swagger.v3.oas.annotations.Operation;
import io.swagger.v3.oas.annotations.Parameter;
import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
import lombok.AllArgsConstructor;
import jakarta.validation.Valid;

import org.springblade.common.constant.CommonConstant;
import org.springblade.core.secure.BladeUser;
import org.springblade.core.secure.annotation.PreAuth;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
import org.springblade.core.secure.utils.AuthUtil;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.BeanUtil;
import org.springblade.core.tool.utils.DigestUtil;
import org.springblade.core.tool.utils.Func;
import org.springblade.modules.signup.pojo.dto.CustomersDTO;
import org.springblade.modules.signup.pojo.entity.QyCardTypesEntity;
import org.springblade.modules.signup.pojo.vo.CustomersVO;
import org.springblade.modules.signup.service.IQyCardTypesService;
import org.springblade.modules.students.controller.QyStudentCardsController;
import org.springblade.modules.students.pojo.entity.QyStudentCardsEntity;
import org.springblade.modules.students.service.IQyStudentCardsService;
import org.springblade.modules.system.pojo.entity.User;
import org.springblade.modules.system.pojo.vo.DataScopeVO;
import org.springblade.modules.system.service.IUserService;
import org.springframework.web.bind.annotation.*;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.springblade.modules.signup.pojo.entity.QyStudentsOrderEntity;
import org.springblade.modules.signup.pojo.vo.QyStudentsOrderVO;
import org.springblade.modules.signup.excel.QyStudentsOrderExcel;
import org.springblade.modules.signup.wrapper.QyStudentsOrderWrapper;
import org.springblade.modules.signup.service.IQyStudentsOrderService;
import org.springblade.core.boot.ctrl.BladeController;
import org.springblade.core.tool.utils.DateUtil;
import org.springblade.core.excel.util.ExcelUtil;
import org.springblade.core.tool.constant.BladeConstant;
import org.springblade.core.tool.constant.RoleConstant;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.stream.Collectors;

import jakarta.servlet.http.HttpServletResponse;
import org.springframework.web.multipart.MultipartFile;

/**
 * 订单管理 控制器
 *
 * @author BladeX
 * @since 2024-06-19
 */
@RestController
@AllArgsConstructor
@RequestMapping("blade-qyClasses/qyStudentsOrder")
@Tag(name = "订单管理", description = "订单管理接口")
public class QyStudentsOrderController extends BladeController {

	private final IQyStudentsOrderService qyStudentsOrderService;
	private final IQyCardTypesService qyCardTypesService;
	private final IUserService userService;
	private final IQyStudentCardsService qyStudentCardsService;
	/**
	 * 订单管理 详情
	 */
	@GetMapping("/detail")
	@ApiOperationSupport(order = 1)
	@Operation(summary = "详情", description  = "传入qyStudentsOrder")
	public R<QyStudentsOrderVO> detail(QyStudentsOrderEntity qyStudentsOrder) {
		QyStudentsOrderEntity detail = qyStudentsOrderService.getOne(Condition.getQueryWrapper(qyStudentsOrder));
		return R.data(QyStudentsOrderWrapper.build().entityVO(detail));
	}


	/**
	 * 订单管理 分页
	 */
	@GetMapping("/list")
	@ApiOperationSupport(order = 2)
	@Operation(summary = "分页", description  = "传入qyStudentsOrder")
	public R<IPage<QyStudentsOrderVO>> list(@Parameter(hidden = true) @RequestParam Map<String, Object> qyStudentsOrder, Query query) {
		IPage<QyStudentsOrderEntity> pages = qyStudentsOrderService.page(Condition.getPage(query), Condition.getQueryWrapper(qyStudentsOrder, QyStudentsOrderEntity.class));

		pages.getRecords().forEach(item->{
			User one = userService.getById(item.getStudentId());//如果不存在
			if(one!= null){
				item.setStudentName(one.getRealName());
			}
			QyCardTypesEntity byId = qyCardTypesService.getById(item.getCardTypeId());
			if(byId!=null){
				item.setCardTypeName(byId.getName());
			}

		});


		return R.data(QyStudentsOrderWrapper.build().pageVO(pages));


	}

	/**
	 * 订单管理 自定义分页
	 */
	@GetMapping("/page")
	@ApiOperationSupport(order = 3)
	@Operation(summary = "分页", description  = "传入qyStudentsOrder")
	public R<IPage<QyStudentsOrderVO>> page(QyStudentsOrderVO qyStudentsOrder, Query query) {
		IPage<QyStudentsOrderVO> pages = qyStudentsOrderService.selectQyStudentsOrderPage(Condition.getPage(query), qyStudentsOrder);
		pages.getRecords().forEach(item->{

			User one = userService.getById(item.getStudentId());//如果不存在
			if(one!= null){
				item.setStudentName(one.getRealName());
			}
			QyCardTypesEntity byId = qyCardTypesService.getById(item.getCardTypeId());
			if(byId!=null){
				item.setCardTypeName(byId.getName());
			}
		});



		return R.data(pages);
	}

	/**
	 * 订单管理 新增
	 */
	@PostMapping("/save")
	@ApiOperationSupport(order = 4)
	@Operation(summary = "新增", description  = "传入qyStudentsOrder")
	public R save(@Valid @RequestBody QyStudentsOrderEntity qyStudentsOrder) {
		return R.status(qyStudentsOrderService.save(qyStudentsOrder));
	}

	/**
	 * 订单管理 修改
	 */
	@PostMapping("/update")
	@ApiOperationSupport(order = 5)
	@Operation(summary = "修改", description  = "传入qyStudentsOrder")
	public R update(@Valid @RequestBody QyStudentsOrderEntity qyStudentsOrder) {
		return R.status(qyStudentsOrderService.updateById(qyStudentsOrder));
	}

	/**
	 * 订单管理 新增或修改
	 */
	@PostMapping("/submit")
	@ApiOperationSupport(order = 6)
	@Operation(summary = "新增或修改", description  = "传入qyStudentsOrder")
	public R submit(@Valid @RequestBody QyStudentsOrderEntity qyStudentsOrder) {
		return R.status(qyStudentsOrderService.saveOrUpdate(qyStudentsOrder));
	}

	/**
	 * 订单管理 删除
	 */
	@PostMapping("/remove")
	@ApiOperationSupport(order = 7)
	@Operation(summary = "逻辑删除", description  = "传入ids")
	public R remove(@Parameter(name = "主键集合", required = true) @RequestParam String ids) {
		return R.status(qyStudentsOrderService.deleteLogic(Func.toLongList(ids)));
	}


	/**
	 * 导出数据
	 */
	@PreAuth(RoleConstant.HAS_ROLE_ADMIN)
	@GetMapping("/export-qyStudentsOrder")
	@ApiOperationSupport(order = 9)
	@Operation(summary = "导出数据", description  = "传入qyStudentsOrder")
	public void exportQyStudentsOrder(@Parameter(hidden = true) @RequestParam Map<String, Object> qyStudentsOrder, BladeUser bladeUser, HttpServletResponse response) {
		QueryWrapper<QyStudentsOrderEntity> queryWrapper = Condition.getQueryWrapper(qyStudentsOrder, QyStudentsOrderEntity.class);
		//if (!AuthUtil.isAdministrator()) {
		//	queryWrapper.lambda().eq(QyStudentsOrder::getTenantId, bladeUser.getTenantId());
		//}
		queryWrapper.lambda().eq(QyStudentsOrderEntity::getIsDeleted, BladeConstant.DB_NOT_DELETED);
		List<QyStudentsOrderExcel> list = qyStudentsOrderService.exportQyStudentsOrder(queryWrapper);
		ExcelUtil.export(response, "订单管理数据" + DateUtil.time(), "订单管理数据表", list, QyStudentsOrderExcel.class);
	}



	@GetMapping("/student/list")
	@ApiOperationSupport(order = 10)
	@Operation(summary = "导入数据", description  = "传入import-student")
	public R stulist(CustomersDTO dto, MultipartFile file) {
		List<CustomersVO> customerList = qyStudentsOrderService.getCustomerList(dto);
		return R.data(customerList);
	}



	public void  addrecord(User one,LinkedHashMap data){
		QyStudentsOrderEntity find= new QyStudentsOrderEntity();
		find.setStudentId(one.getId());
		QyStudentsOrderEntity findOrder = qyStudentsOrderService.getOne(Condition.getQueryWrapper(find));
		if(findOrder == null){
			QyStudentsOrderEntity order= new QyStudentsOrderEntity();
			order.setStudentId(one.getId());
			order.setPayStatus("1");
			order.setAmount(data.get(3).toString());
			order.setOriginAmount(data.get(3).toString());
			order.setPaidAmount(data.get(4).toString());
			order.setNote(data.get(2).toString());
			String[] split = data.get(2).toString().split(" ");
//							卡名 课时 到期时间
			if(split.length==3) {
				order.setClassHour(split[1].replace("课时",""));
				QyCardTypesEntity qyCardTypes = new QyCardTypesEntity();
				qyCardTypes.setName(split[0]);
				QyCardTypesEntity one1 = qyCardTypesService.getOne(Condition.getQueryWrapper(qyCardTypes));
				if(one1 != null){
					order.setCardTypeId(one1.getId());
					QyStudentCardsEntity qyStudentCardsEntity = new QyStudentCardsEntity();
					qyStudentCardsEntity.setStudentId(one.getId());
					qyStudentCardsEntity.setCardTypeId(one1.getId());
					QyStudentCardsEntity one2 = qyStudentCardsService.getOne(Condition.getQueryWrapper(qyStudentCardsEntity));
					if(one2 == null){
						qyStudentCardsEntity.setClassHour(order.getClassHour());
						qyStudentCardsService.save(qyStudentCardsEntity);
					}
				}




				String sdate = split[2].replace("(有效期到", "")
					.replace(")", "")
					.replace("年", "-")
					.replace("月", "-")
					.replace("日", "");
				SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
				//1.string->date
				try {
					if(!sdate.isEmpty()){
						Date parse = dateFormat.parse(sdate);
						order.setExpirationTime(parse);
					}
				} catch (ParseException e) {
					throw new RuntimeException(e);
				}

			}
			//添加订单
			qyStudentsOrderService.save(order);
		}else {
			String[] split = data.get(2).toString().split(" ");
			if(split.length==3) {
				QyCardTypesEntity qyCardTypes = new QyCardTypesEntity();
				qyCardTypes.setName(split[0]);
				QyCardTypesEntity one1 = qyCardTypesService.getOne(Condition.getQueryWrapper(qyCardTypes));
				if (one1 != null) {

					QyStudentCardsEntity qyStudentCardsEntity = new QyStudentCardsEntity();
					qyStudentCardsEntity.setStudentId(one.getId());
					qyStudentCardsEntity.setCardTypeId(one1.getId());
					QyStudentCardsEntity one2 = qyStudentCardsService.getOne(Condition.getQueryWrapper(qyStudentCardsEntity));
					if (one2 == null) {
						qyStudentCardsEntity.setClassHour(split[1].replace("课时",""));
						qyStudentCardsEntity.setAmount(data.get(3).toString());
						qyStudentCardsEntity.setCourseCancellation("1");
						String sdate = split[2].replace("(有效期到", "")
							.replace(")", "")
							.replace("年", "-")
							.replace("月", "-")
							.replace("日", "");
						SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
						//1.string->date
						try {
							if(!sdate.isEmpty()){
								Date parse = dateFormat.parse(sdate);
								qyStudentCardsEntity.setEndTime(parse);
							}
						} catch (ParseException e) {
							throw new RuntimeException(e);
						}

						qyStudentCardsService.save(qyStudentCardsEntity);
					}
				}
			}
		}
	}


	@PostMapping("import-student")
	@ApiOperationSupport(order = 10)
	@Operation(summary = "导入数据", description  = "传入import-student")
	public R importStudent( Map<String, Object> map, MultipartFile file) {
		try {
			// 定义解析监听器，并通过实现方法获取单元格数据
			final String[] social_code = {""};

			//基本信息解析 0
			AnalysisEventListener<Object> baseListener = new AnalysisEventListener<Object>() {
				List<Object> listData = new ArrayList<>();
				@Override
				public void invoke(Object data, AnalysisContext context) {
					listData.add(data);
				}
				@Override
				public void doAfterAllAnalysed(AnalysisContext context) {

					for(int i=0;i<listData.size();i++){
						LinkedHashMap data = (LinkedHashMap) listData.get(i);
						//先添加客户表再加到报名表
						User user = new User();
						user.setTenantId(AuthUtil.getTenantId());
						user.setAccount(data.get(1).toString());
						user.setPassword(DigestUtil.encrypt(CommonConstant.DEFAULT_PASSWORD));//设置默认密码
						User one = userService.getOne(Condition.getQueryWrapper(user));//如果不存在
						if(one== null){
							//如果不存在则添入姓名并添加。
							user.setName(data.get(0).toString());
							user.setRealName(data.get(0).toString());
							//先写死
							user.setRoleId("1803606436115193858");
							user.setDeptId("1803588450055012353");
							user.setPostId("1803606762721452034");
							userService.save(user);
							addrecord(user,data);
						} else{
							addrecord(one,data);
						}
					}
				}
			};

			EasyExcel.read(file.getInputStream(), baseListener).sheet(0).doRead();

		} catch (Exception e) {
			e.printStackTrace();
			return R.data("导入失败");
		}
		return R.data("导入成功");
	}


}
